insert overwrite table yl_ods.yl_tms_shipment partition(dt)
select
id
,shipment_no
,distribution_type
,business_attribute
,shipment_name
,shifts
,vehicleline_type
,shipment_state
,line_id
,line_code
,line_name
,start_id
,start_code
,start_name
,start_financial_center_id
,start_financial_center_code
,start_financial_center_desc
,end_id
,end_code
,end_name
,end_financial_center_id
,end_financial_center_code
,end_financial_center_desc
,cnt
,mileage
,total_runtime
,standard_speed
,actual_mileage
,actual_total_runtime
,actual_standard_speed
,planned_departure_time
,planned_arrival_time
,actual_departure_time
,actual_arrival_time
,vehicle_groupid
,vehicle_typegroup
,actual_vehicle_groupid
,actual_vehicle_typegroup
,plate_number
,load_weight
,vehicle_volume
,null as driver_name
,null as driver_contact
,vehicletype_id
,vehicletype_name
,vehicle_class_id
,vehicle_class_name
,transport_type
,operation_model
,trailer_number
,quotation_model
,load_time
,lock_time
,clock_time
,unlock_time
,unload_time
,carrier_id
,carrier_type
,carrier_name
,create_by
,create_by_name
,create_time
,update_by
,update_by_name
,update_time
,dt
from jms_ods.yl_tms_shipment
where dt = '{{ execution_date | cst_ds }}' ;